CREATE TABLE [dbo].[JOL_EmailManagement_Email]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[Admin_LoginID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[sender_address] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[topic] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[recipients] [varchar] (max) COLLATE Chinese_PRC_CI_AS NULL,
[copy_to] [varchar] (max) COLLATE Chinese_PRC_CI_AS NULL,
[contents] [text] COLLATE Chinese_PRC_CI_AS NULL,
[sign] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[mark] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[add_time] [smalldatetime] NULL,
[user_add] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[update_time] [smalldatetime] NULL,
[user_update] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[send_state] [bit] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_EmailManagement_Email] ADD CONSTRAINT [PK_JOL_EmailManagement_Email] PRIMARY KEY CLUSTERED  ([id]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'添加时间', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Email', 'COLUMN', N'add_time'
GO
EXEC sp_addextendedproperty N'MS_Description', N'登录用户的ID（发送账户）', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Email', 'COLUMN', N'Admin_LoginID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'正文', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Email', 'COLUMN', N'contents'
GO
EXEC sp_addextendedproperty N'MS_Description', N'抄送人', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Email', 'COLUMN', N'copy_to'
GO
EXEC sp_addextendedproperty N'MS_Description', N'标签', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Email', 'COLUMN', N'mark'
GO
EXEC sp_addextendedproperty N'MS_Description', N'收件人', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Email', 'COLUMN', N'recipients'
GO
EXEC sp_addextendedproperty N'MS_Description', N'发送状态', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Email', 'COLUMN', N'send_state'
GO
EXEC sp_addextendedproperty N'MS_Description', N'签名', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Email', 'COLUMN', N'sign'
GO
EXEC sp_addextendedproperty N'MS_Description', N'邮件主题', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Email', 'COLUMN', N'topic'
GO
